The social community is structured around data, a lot of that data is stored in different types of databases. The meaning of this essay is to develop an interactive tool that will change the way database visualization is done, and also to research in which fields a tool of this type can be used. With the help of different methods we discovered areas where it could be of use, such as; presentation of a database, development and documentation of a database. The primary goal of the prototype was to make viewing of database structures easier, even people without prior database knowledge should be able to understand the structure. During the development we used prototypes.

Company X develops a laboratory information system (LIS) called System Y. The informationsystem has a two-tier database architecture consisting of a production database and a historicaldatabase. A database constitutes the backbone of a IS, which makes the design of the databasevery important. A poorly designed database can cause major problems within an organization.The two databases in System Y are poorly modeled, particularly the historical database. Thecause of the poor modeling was unclear concepts.

During the last years the need for real-time database services has increased due to the growing number of data-intensive applications needing to enforce real-time constraints. The COMponent-based Embedded real-Time database (COMET) is a real-time database developed to meet these demands. COMET is developed using the AspeCtual COmponent-based Real-time system Development (ACCORD) design method, and consists of a number of components and aspects, which can be composed into a number of different configurations depending on system demands, e.g., Quality of Service (QoS) management can be used in unpredictable environments. In embedded systems with requirementson high up-time it may not be possible to temporarily shut down the system for reconfiguration. Instead it is desirable to enable dynamic reconfiguration of the system, exchanging components during run-time.

This report explains the need to develop a configuration manager that handles transmission equipment which exists in the Swedish Defence telecommunications network. The configuration module will display the configurations and compatibility among the equipment and their software which are all part of the network.Also included in this report are tools, methods and results for the development of a prototype for the configuration manager. The prototype consists fundamentally of a database assisted by a user friendly website.The transmission equipment handles a lot of important transmission of information and is in the hands of a department of SAAB, OFGCA, by orders from the Swedish Defence Materiel Administration (FMV). Within the work included in this order exists a continuous update of both software and hardware which the equipment consists of. Therefore it?s highly important that there is a monitoring of which of the software and hardware is compatible with one another, ensuring that the functions of the system work properly.The consistent updating has resulted in compatibility issues between components and because of this, a need for a configuration manager has arisen..

Svenskt Rockarkiv is an organization located in Hultsfred, Sweden. Its goal is to collect and document the history of Swedish rock music. The archive contains several types of documentation, such as audio recordings, photographs, posters, video recordings and books representing Swedish rock music history. In order to store information about the audio recordings in the archive, Svenskt Rockarkiv uses a SQL Server 2000 database and a client application written in Microsoft.NET C# and Windows Forms. The purpose of this degree project is to audit the database and windows client, since the organization has needs of new functionality.

AbstractAs a developer of database-driven applications you will be faced with difficult choices, when it comes to choosing database, server and programming language. For the result to be satisfactory it requires the different techniques to interact well with each other and also fulfill performance expectations. This is even more important when the application is deployed to the cloud and the response time plays a major role.This paper evaluates different databases and their performance. To test the databases there was an application made in the server script language PHP or Hypertext Preprocessor and it was deployed to Windows Azure cloud platform. The test applications task is to call and load databases by controlled requests which creates, reads, updates and deletes data in an relatively large extent.The results shows that locale databases or databases in the same data center as the server generates the fastest response.

Risk management is a key competency that is constantly being researched how it can be improved within project management. The risk management process consists of four major steps: identify risks, assess the risks? significance on the project, evaluate and address the key risks and follow up.The majority of companies seem to neglect certain identified risks, and decide not to mitigate if the risk does not cause adverse effects to the business. To counteract undesirable consequences and help organisations to become more effective at managing risks an initial work has been conducted for a risk repository.The project develops a proposal on the design of a risk repository which aim to effectively support a database implementation. The study includes literature studies which resulted in a relational model for database implementation.

SMC is in the process of developing a micro simulation model. The existing micro simulation model developed at Cornell University for US data, CorSim, is one of the fundamental parts for the new micro simulation at SMC. To develop the Swedish model, Swedish data on all individuals in Sweden during 11 years are also available. These data are organized in a database. This paper describes the process of rebuilding the database to a more useful structure.

This thesis work is executed at Business Unit Ericsson Test Environment (BETE), in Linköping. BETE is the department at Ericsson, which is responsible for the operation and maintenance of the company's Operations Support System (OSS). Their management system was outdated and they wanted it to be updated and it also required new features. The database needed to be replaced and the data migrated to a new database without licensing costs. The system also needed a part where employees could manage existing users.As a programming language PHP was chosen for its dynamic possibilities, platform independence and good support for database intergration.

The relational database model was defined in the 1970?s and is the dominating database type today.  The main difference between data from a relational database and a hierarchical data structure is that the relational database stores records in tables. The records have no particular order, but can include links in terms of relationships with other records. A hierarchical structure organizes data in the form of a tree structure  and  can for an example be found in organizational structures in which different levels involves different responsibilities. If the data stored in a relational database is to be presented in a hierarchically, a conversion of the data structure is required. The intention of this paper is to describe how such a conversion can be performed.  To investigate the conversion methods, case studies has been conducted on the basis of a specific organization?s hierarchical structure.

Creating a database to manage medical data is not the easiest. We create a database to be used for a presentation tool that presents medical data about patients that is stored in the database. We examine which of the three databases, MySQL with relational design, MySQL with EAV design and MongoDB that are best suited for storing medical data. The analysis i performed in two steps. The first step handles the database that is most effective to retriev data. The second step examines how easy it is to change the structure of the various databases. The results show that depending on whether efficiency or maintenance is most important, different databases are the best choise. MySQL with relational design proves to be most effective while MongoDB is the easiest to maintain..

The Center for Genomics and Bioinformatics (CGB) is an academic department at Karolinska Institute. Generally stated, the CGB department is committed to the generation and management of genetic information by approaches aiming at elucidating the connection between genes, protein and function.WiGID is a genome information database that is available through WAP (Wireless Application Protocol).Our version of WiGID is based on WML, PHP and PostgreSQL as a database server.One of the changes on the old WiGID application was the creation of a relational database with seven tables and one view, instead of the file that represented the database on the old version. We also changed the script language from python to PHP.The search engine ability has been extended with three new search alternatives for a user to choose from. Each choice leads to other, sometimes multiple choices.A GUI has been created for the administrator, to be able to insert information into the database.The structure of the search engine is primarily for narrowing down the search result on the phone display, thereby making the search efficient..

The goal of this project was to create a web-based, crowd-sourced, correlational database, that easily allowed users to submit objects and receive correlated objects as results. The webservice was created in the web development languages of HTML, CSS, PHP and Javscript, with MySQL to handle the database. Simultaneous development was kept in check with the aid of the source code management system GIT. Upon completion, the service contained several HTML-views, the ability to add and rate objects, a per-object dedicated page with information parsed from Wikipedia.org, and a view with objects ranked in accordance to the preferences specific to the current user. Roughly a month after the beginning of development, the website was publicly launched and promoted in order to collect data, and improvements were added to the website as needed.

The purpose of this study was to build a database for point-bearing piles in dense noncohesive soil, predominantly moraine. Further, the database was analysed and areas with difficult geotechnical conditions was identified.The database includes for point-bearing piles driven to refusal in moraine. Piles with mainly shaft friction have been excluded. Only concrete piles have been included. Geographically the database covers almost all geotechnical conditions of Sweden.

Risk management is a key competency that is constantly being researched how it can be improved within project management. The risk management process consists of four major steps: identify risks, assess the risks? significance on the project, evaluate and address the key risks and follow up.The majority of companies seem to neglect certain identified risks, and decide not to mitigate if the risk does not cause adverse effects to the business. To counteract undesirable consequences and help organisations to become more effective at managing risks an initial work has been conducted for a risk repository.The project develops a proposal on the design of a risk repository which aim to effectively support a database implementation. The study includes literature studies which resulted in a relational model for database implementation.